Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have created the following cards at the top of my report:
I have added a Page level filter on NET SALES:
Level 1 is a hierarchy and Sales exists within Net Sales hence why the card visual has not gone BLANK.
But my other cards from Sales + Open Orders to Contribution Margin have gone blank. I have tried using REMOVEFILTERS as below:
Sales + Open Orders = CALCULATE(
[Amount],
'Profitability Account'[Description] = "Sales + Open Orders",
REMOVEFILTERS('Profitability Account'[Description])
)
I even added Level 1 in remove filters but that doesn't work either. How can I fix this?
Thanks,
S
I suggest you to use ALL(). Check it out here: https://learn.microsoft.com/en-us/dax/all-function-dax
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |