Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello PBI Community,
I need help to figure out how I can calculate a Aggregated Total using Distinct Totals. Specifically , the Denominator to calculate a Percent of total. Unfortunately , my table has duplicates so I tried the following:
VAR Asum=
Solved! Go to Solution.
I figured it out. Here is the formula that worked for me.
VAR Asum=
I figured it out. Here is the formula that worked for me.
VAR Asum=
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |