Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Sum the count results of a measure

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.

1 REPLY 1
SivaMani
Resident Rockstar
Resident Rockstar

@Anonymous,

 

Create a new measure with SUMX -  SUMX(<tablename>,<count measure>)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors