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.
Hello All,
Required your assistance, i want to create measure for percentage calculation used Distinctcount, filter & sumx not getting correct result.
Measure1:
In below screenshot, i have used %GT option for 3rd column which is giving correct result, (Total is 15where discount of OppId/ total 1/15(7%).
In last columns % is calculated on total which is 20 (1/20=5%), i want to create dax based on 2nd column that is discount total
Thanks in advance for your help.
Regards,
Hari
Solved! Go to Solution.
@harirao , Not very clear .
You can create % of tota with a measure like
divide([discount], calculate([discount], all(Table))
divide([discount], calculate([discount], allselected(Table))
Hi , @harirao
Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.
Best Regards,
Community Support Team _ Eason
@harirao , Not very clear .
You can create % of tota with a measure like
divide([discount], calculate([discount], all(Table))
divide([discount], calculate([discount], allselected(Table))
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |