Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a Created Measure that is working correctly [Asthma M%]. However, I need to create an additional created measure that is essentially the same...but that ignores the Page Slicer [Group_ID].
Here is my existing Created Measure:
Solved! Go to Solution.
@AW1976NOVA , Try like
Asthma M% = CALCULATE(DIVIDE(CALCULATE(DISTINCTCOUNT('Data Files'[MBR_ID]), Filter('Data Files','Data Files'[Asthma_IND] = "Asthma")),(CALCULATE(DISTINCTCOUNT('Data Files'[MBR_ID])))), all(Table [Group_ID]))
But if it is page level filter , than I doubt it will work
@AW1976NOVA , Try like
Asthma M% = CALCULATE(DIVIDE(CALCULATE(DISTINCTCOUNT('Data Files'[MBR_ID]), Filter('Data Files','Data Files'[Asthma_IND] = "Asthma")),(CALCULATE(DISTINCTCOUNT('Data Files'[MBR_ID])))), all(Table [Group_ID]))
But if it is page level filter , than I doubt it will work
You have a bit of extra code in your first measure and you should avoid filtering an entire table and just filter the column you need, like so.
Asthma M% =
DIVIDE (
CALCULATE (
DISTINCTCOUNT ( 'Data Files'[MBR_ID] ),
FILTER (
VALUES ( 'Data Files'[Asthma_IND] ),
'Data Files'[Asthma_IND] = "Asthma"
)
),
DISTINCTCOUNT ( 'Data Files'[MBR_ID] )
)
Then, for the all groups version you could do.
Astma M% All Groups =
CALCULATE ( [Astma M%], ALL ( 'Data Files'[Group ID] ) )
User | Count |
---|---|
93 | |
85 | |
77 | |
68 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |