Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team , I am trying to calculate % Total error for a month ( Error for that month / Total lines in that month )
I am getting stuck a 2 point
1. Line Total changes if I filter out the data . Ex. Below screenshort it's with not filter
2. As soon I add " Error" count . The total in "Total line" coulmn changes
1. How can I solve this issue , were original count " Total line" remains unchanged while adding Error counts column?
2. How can I calcluate % of error per month ? considering Error in that month/ Total line in that month
I have reveiwed post on forum but unfortunately wasn't able to figure this out . Any help would be highly appreciated .
Hi @PoojaPandey
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster?
If not, please provide more details with your desired output and pbix file without privacy information (or some sample data).
Thank you very much for your kind cooperation!
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
did you apply the filter on the table?
if so, you can use ALL function
https://learn.microsoft.com/EN-US/dax/all-function-dax?wt.mc_id=DP-MVP-5004616
or removefilter
Proud to be a Super User!
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |