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 having incorrect Rankx Total on my measure. see screen shot & DAX query below, When i filter on fiscal Year, The RankTotal changes to 13 which is incorrect instead of 12.
Solved! Go to Solution.
Hi @Anonymous ,
You can use the HASONEVALUE() function to fix the Total incorrect
Here are the steps you can follow:
Create a measure.
Total_Incorrect =
var _table=SUMMARIZE('dim_sites','dim_sites'[Division],"_value",[Table Rank2])
return
IF(HASONEVALUE('dim_sites'[Division]),[Table Rank2],SUMX(_table,[_value]))
Result
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Anonymous ,
You can use the HASONEVALUE() function to fix the Total incorrect
Here are the steps you can follow:
Create a measure.
Total_Incorrect =
var _table=SUMMARIZE('dim_sites','dim_sites'[Division],"_value",[Table Rank2])
return
IF(HASONEVALUE('dim_sites'[Division]),[Table Rank2],SUMX(_table,[_value]))
Result
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Look at the DAX correctly let me know if i need to include the date dim.. or which filter context I'm missing.
Hi,
Do you have any blank value hidden ?
It must be related to context filters, because as soon as you are on a total (=no filter) or in a visual card (= no filter) you get 13 instead of 12. It means that your ranking without filters is incorrect.
Try to look for missing filters in your results...
Hope it helps a bit
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |