Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have to write one measure which counts the number of Rows, but it should have two type of Filter.
Like the below image: We need count via Company wise. But should have 2 conditions
1. For company C1 and E1 we need check Cases number =1 and Admission = "N"
2. Rest of other company we need to check Case Number = 1
Can you please help me how I write measurer to calculate a count.
Solved! Go to Solution.
try this
Measure = VAR C1_E1_filter = FILTER('Table','Table'[Company] in {"C1","E1"} && 'Table'[Admission] = "N" && 'Table'[# Cases] =1) VAR C1_E1 = CALCULATE(COUNTROWS('Table'),C1_E1_filter) VAR Else_filter = FILTER('Table','Table'[Company]<>"C1" && 'Table'[Company]<>"E1" && 'Table'[Admission] = "N") VAR Else_value = CALCULATE(COUNTROWS('Table'),Else_filter) RETURN C1_E1+Else_value
try this
Measure = VAR C1_E1_filter = FILTER('Table','Table'[Company] in {"C1","E1"} && 'Table'[Admission] = "N" && 'Table'[# Cases] =1) VAR C1_E1 = CALCULATE(COUNTROWS('Table'),C1_E1_filter) VAR Else_filter = FILTER('Table','Table'[Company]<>"C1" && 'Table'[Company]<>"E1" && 'Table'[Admission] = "N") VAR Else_value = CALCULATE(COUNTROWS('Table'),Else_filter) RETURN C1_E1+Else_value
Thanks, it works...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |