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 Team,
Kindly suggest dax to calculate total based on half-yearly, the input and output are as shown in image.
The total has to be displayed based on year and category slicer selection
Thanks,
Jenani
Solved! Go to Solution.
HI @jenani_user ,
Pls create the below measure:
sumvalue = CALCULATE(SUM('Table'[overall]),ALLSELECTED('Table'),'Table'[Half-yearly]=MAX('Table'[Half-yearly]))
Outputresult:
You could download my pbix file to learn more details.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
HI @jenani_user ,
Pls create the below measure:
sumvalue = CALCULATE(SUM('Table'[overall]),ALLSELECTED('Table'),'Table'[Half-yearly]=MAX('Table'[Half-yearly]))
Outputresult:
You could download my pbix file to learn more details.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |