Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All, wonder if you can help with a Dax solution, I've got 2 columns, 1 date, second Answer, is values that only have 2 variants, I.e Yes or No
I need to transform the data to a date column, %yes column and %no column
Maybe I need to pivot out three 2 columns but cannot figure it out, help will be appreciated
Solved! Go to Solution.
Hi,
Measure1 = COUNTROWS(Data)/CALCULATE(COUNTROWS(Data),ALL(Data[Answer]))
Format Measure1 as a %.
Hope this helps.
Hi , @samue_an
Could you please tell me whether your problem has been solved?
If it is, please mark the helpful replies or add your reply as Answered to close this thread.
More people will learn new things here. If you haven't, please feel free to ask.
Best Regards,
Community Support Team _ Eason
Hi,
Measure1 = COUNTROWS(Data)/CALCULATE(COUNTROWS(Data),ALL(Data[Answer]))
Format Measure1 as a %.
Hope this helps.
The information you have provided is not making the problem clear to me. Can you please explain with an example.
if you need % of the total then
countrows(Table)/calculate(countrows(Table),all(Table))
Appreciate your Kudos.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |