Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys, I'm trying to convert the following formulas from Excel to DAX, but they don't seem to be working as they should. I tried a DAX and I'm getting the overall numbers correct, but when I divide them into regions, that values don't add up as they should.
Data!D = Region
Data!AQ = TAT
=COUNTIFS(Data!D: D,B34,Data!AQ:AQ,"<6")/COUNTIFS(Data!D: D,B34,Data!AQ:AQ,"<>") Measure = DIVIDE( CALCULATE(COUNTROWS('Timeliness Data'), FILTER('Timeliness Data', 'Timeliness Data'[TAT] <= 5)) , COUNTROWS(ALL('Timeliness Data'))) )
Solved! Go to Solution.
I think I got it: I just had to remove the ALL from the denominator.
Measure = DIVIDE( CALCULATE(COUNTROWS('Timeliness Data'), FILTER('Timeliness Data', 'Timeliness Data'[TAT] <= 5)) , COUNTROWS('Timeliness Data')) )
I think I got it: I just had to remove the ALL from the denominator.
Measure = DIVIDE( CALCULATE(COUNTROWS('Timeliness Data'), FILTER('Timeliness Data', 'Timeliness Data'[TAT] <= 5)) , COUNTROWS('Timeliness Data')) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
115 | |
105 | |
95 | |
79 | |
72 |