Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a calculated measure that counts how many people were below target comparing the results from Tbale 1, vs the targets from Table 2. There are other filters applied (3 specifically, Month, year and Type) that show me the results depending on what I select.
However, I need to calculate the total sum of that count depending on the filters.
The formula used to determine the count is:
calculate(distinctcount('Table 1'[Name ID)]),filter('Table 1','Table 1'[Units]<AVERAGE(Table2[Targets])),filter('DOR Data',not(isblank('Table 1'[Units]))))
The results of the counts for the filters selected are 4 numbers: 39, 21, 52, 40
I want to obtain the total sum of those five numbers (should be 152 (like a constant that changes depending only on the filters)) as an independent measure.
How can I do that?
Thank you for your support.
@Anonymous,
Create a new measure with SUMX - SUMX(<tablename>,<count measure>)
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |