Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello Community,
My formula is working fine but total is not showing right numbers for Matrix Visuals.
Measure = DIVIDE(SUM('Totals'[Plan Rate]),SUM('Totals'[Invoice]),0)
I also tried the second measure formula but not working for me.
Measure = sumx(Totals,DIVIDE(SUM('Totals'[Plan Rate]),SUM('Totals'[Invoice]),0))
Dataset: 1 (Region)
Region | Country |
USA | Newyork |
CANADA | Toronto |
Europe | London |
Dataset:2 (Market)
Market | Derived |
BioPharma | Bio |
Clinical | Cli |
Forensic | For |
Dataset:3 (Totals)
Plan Rate | Invoice | Country | Derived | Country |
5 | 1 | Bio | Newyork | |
10 | 2 | Cli | Toronto | |
15 | 3 | For | London | |
25 | 4 | Bio | Country | |
30 | 5 | Cli | Newyork | |
35 | 6 | For | Toronto | |
40 | 7 | Bio | London | |
45 | 8 | Cli | Country | |
50 | 9 | For | Newyork |
Solved! Go to Solution.
Hello, @tejapowerbi123
So, something like this?
I created 3 measures, Sum of Invoice, Sum of Plan Rate and your Division:
Total Plan Rate = SUM('Totals'[Plan Rate])
Total Inovice = SUM('Totals'[Invoice])
Divided = SUMX('Totals', DIVIDE([Total Plan Rate], [Total Inovice], 0))
Hello, @tejapowerbi123
So, something like this?
I created 3 measures, Sum of Invoice, Sum of Plan Rate and your Division:
Total Plan Rate = SUM('Totals'[Plan Rate])
Total Inovice = SUM('Totals'[Invoice])
Divided = SUMX('Totals', DIVIDE([Total Plan Rate], [Total Inovice], 0))
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
109 | |
107 | |
93 | |
68 |
User | Count |
---|---|
167 | |
130 | |
129 | |
94 | |
91 |