![Counting [Aggregating] Values in Power BI when Inactive Relationship is Present @AbhishekAgarrwal](https://i.ytimg.com/vi/agLJq0YtOwk/maxresdefault.jpg)
Uploaded June 2025 | Updated September 2026, 21 minutes ago
Power BI DAX Formula tutorial for counting values when there inactive relationships and your output is coming incorrectly. Now this formula can be applied to count or sum or avg or any aggregation function where you want the aggreation based inactive relationship.
Connect with me:
LinkedIn - linkedin.com/in/abhishek-agarwal-9549876
Twitter - https://x.com/agarrwal7
Need Advance Dashboard Training? Contact - abhishek.agarrwal@gmail.com
Advance Dashboard Training Details - docs.google.com/presentation/d/1ArqwjW9F-1Q-Zz2wV0SxwUrp8G_Cn8ScP4pi1v9wkhw/edit?usp=sharing
Join my private group for communcations - tinyurl.com/yd65vnf3
Dataset -
docs.google.com/spreadsheets/d/1a5c2Ubetp3eUW3ctySSyyOVVdk5UfiYYuTbIMKsIB0k/edit?usp=sharing
Tutorial Sheet - docs.google.com/spreadsheets/d/1UlV8vTxzcCR2WaYUYfL-JI_6ae1aOTPqORU1YjLfuSk/edit?usp=sharing
Power BI DAX Formula tutorial for counting values when there inactive relationships and your output is coming incorrectly. Now this formula can be applied to count or sum or avg or any aggregation function where you want the aggreation based inactive relationship.
Connect with me:
LinkedIn - linkedin.com/in/abhishek-agarwal-9549876
Twitter - https://x.com/agarrwal7
Need Advance Dashboard Training? Contact - abhishek.agarrwal@gmail.com
Advance Dashboard Training Details - docs.google.com/presentation/d/1ArqwjW9F-1Q-Zz2wV0SxwUrp8G_Cn8ScP4pi1v9wkhw/edit?usp=sharing
Join my private group for communcations - tinyurl.com/yd65vnf3
Dataset -
docs.google.com/spreadsheets/d/1a5c2Ubetp3eUW3ctySSyyOVVdk5UfiYYuTbIMKsIB0k/edit?usp=sharing
Tutorial Sheet - docs.google.com/spreadsheets/d/1UlV8vTxzcCR2WaYUYfL-JI_6ae1aOTPqORU1YjLfuSk/edit?usp=sharing
![Counting [Aggregating] Values in Power BI when Inactive Relationship is Present](https://i.ytimg.com/vi/agLJq0YtOwk/mqdefault.jpg "Counting [Aggregating] Values in Power BI when Inactive Relationship is Present
Power BI DAX Formula tutorial for counting values when there inactive relationships and your output is coming incorrectly. Now this formula can be applied to count or sum or avg or any aggregation function where you want the aggreation based inactive relationship.
Connect with me:
LinkedIn - https://www.linkedin.com/in/abhishek-agarwal-9549876/
Twitter - https://x.com/agarrwal7
Need Advance Dashboard Training? Contact - abhishek.agarrwal@gmail.com
Advance Dashboard Training Details - https://docs.google.com/presentation/d/1ArqwjW9F-1Q-Zz2wV0SxwUrp8G_Cn8ScP4pi1v9wkhw/edit?usp=sharing
Join my private group for communcations - https://tinyurl.com/yd65vnf3
Dataset -
https://docs.google.com/spreadsheets/d/1a5c2Ubetp3eUW3ctySSyyOVVdk5UfiYYuTbIMKsIB0k/edit?usp=sharing
Tutorial Sheet - https://docs.google.com/spreadsheets/d/1UlV8vTxzcCR2WaYUYfL-JI_6ae1aOTPqORU1YjLfuSk/edit?usp=sharing")
