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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
REGHnoob
Frequent Visitor

Count values from measure that's calculated from two tables

Hi all

Honestly I feel a bit silly. But I just can't get my head around this supposedly simple problem.

 

I have a measure (M3) that calculates the ratio between two other measures (M1 and M2). M1 and M2 are based on values from separate tables.

 

The two separate tables are both related to  date, time and location dimensions. Table 1 is further related to a handfull of type dimensions. I need to be able to dynamically slice by both type, date, time and location. 

 

T1 is about 40 mill rows and T2 is about 5 mill rows. Size and not least datasources prevent me from creating a hybrid table so the soulution must be entirely measure based.

 

M1 averages the sum pr day and hour based on the quarter column.

M2 averages the sum pr day and hour based on the Value column

M3 divides M2 with M1 to return the ratio between the two

Easy.

 

How do I count the number of times the ratio (M3) exceeds a value  (i.e. 5) and display the count in a matrix with location, date, time and types from the different dimensions.

 

T1 on the left T2 on the right

Table for M1Table for M1Table for M2Table for M2

 

 Best regards

K

0 REPLIES 0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.