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 Power BI team,
I posted this message yesterday but it seems it does not appear in the forum and I will repost again.
When I select "All" in the Sector slicer, all the reporting view generate the correct figure, and everything is fine... until....
PROBLEM:
Until when I select a specific value in the Sector slicer, ....
Problem 1 - the sector percentage figure section generate wrong value (see Q1). In this example, I select resources in the sector dropdown, and the Resource percentage is 100% which is correct but others are wrong.
Problem 2 - in Q2, there should be on 7 records with all having Target machine status of "Assessed" but the table provides more than 7 rows.
My Dax formula:
All individual sector percentage is computed with individual Nominator divided by a common denominator
Denominator -
Solved! Go to Solution.
Hi Cheenu Singh,
I managed to find the solution. It is my Dax problem.
The correct DAX should be
MeasureResource = Calculate(Countrows(filter('Asssessment_Action_20190219',
'Asssessment_Action_20190219'[Sector]="RESOURCES")),
DATESINPERIOD('Asssessment_Action_20190219'[Last Assessment Date1].[Date], TODAY(),-13,MONTH))/ [MeasureTotal]
I will close this issue
thanks.
Hi @Anonymous
It will be good if you can share data and pbix file on OneDrive / Google Drive and post the link here to better understand and arrive at a solution.
Cheers
CheenuSing
Hi Cheenu Singh,
I managed to find the solution. It is my Dax problem.
The correct DAX should be
MeasureResource = Calculate(Countrows(filter('Asssessment_Action_20190219',
'Asssessment_Action_20190219'[Sector]="RESOURCES")),
DATESINPERIOD('Asssessment_Action_20190219'[Last Assessment Date1].[Date], TODAY(),-13,MONTH))/ [MeasureTotal]
I will close this issue
thanks.
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |