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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Ulal
New Member

Divide Two Measures which has filters

Hi Team, i am facing issue in dividin two measures which has row level filters on it. when iam trying DIVIDE function its throwing me error. Help me out here.

Measure 1 = COUNTROWS(FILTER(ADDCOLUMNS(SUMMARIZE('SV Demo','SV Demo'[NationalIdNo],"Distinctpolicies", DISTINCTCOUNT('SV Demo'[PolicyTypeCd])), "policycount", [Distinctpolicies]), [policycount] =2)).

Measure 2 = CALCULATE(DISTINCTCOUNT('SV Demo'[NationalIdNo]),'SV Demo'[PolicyTypeCd] = "BE")

Measure 3 = CALCULATE(DISTINCTCOUNT('SV Demo'[NationalIdNo]), 'SV Demo'[PolicyTypeCd] = "BI")

Measure 4 = Distinctcount('SV Demo'[NationalIdNo]).

 

I need 3 New measures by Dividing (1st measure with 4th Measure) ,  (2nd Measure with 4th Measure),  (3rd Measure with 4th Measure)

1 REPLY 1
amitchandak
Super User
Super User

@Ulal , these measures should work, please share error you are getting

 

Divide([Measure 1],[Measure 4])

 

Divide([Measure 2],[Measure 4])

 

Divide([Measure 3],[Measure 4])

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.