Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Having trouble with my calculation of percentage.
Table contains the Acct codes with Amount. Following measure is for calculating the % of puchase amount ( Acct code = 1000) on each accounts .
Basically, dividing the transaction amount of each account codes by the transaction amount with acct code = "1000"
I tried using ALL , but did not work. Attaching the pbix. Expected results is above, but need to exclude 1000 and show the rest of 3 acct codes.
https://drive.google.com/file/d/1z5bzSReY4-hJpn5FdFiHEvUj6sPn4oOs/view?usp=sharing
Solved! Go to Solution.
@Pbi07 , try like
% of Purch = DIVIDE ( calculate(SUM('Transaction'[Amount]),filter('Transaction', 'Transaction'[Acct Code]<> "1000")),[Total Purch], blank() )
@Pbi07 , try like
% of Purch = DIVIDE ( calculate(SUM('Transaction'[Amount]),filter('Transaction', 'Transaction'[Acct Code]<> "1000")),[Total Purch], blank() )
User | Count |
---|---|
86 | |
81 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |