Forum Discussion

redgun24's avatar
redgun24
New Member
6 years ago
Solved

DAX Help - Calculating Count at Subtotal Level

Hi all,   New to DAX. I'm trying to only show conflicts (1, 2, 3, 4, 5) in the below visualization that have more that one entitlement (AP Invoice Entry, AP Supplier Master, etc.). For the example ...
  • az38's avatar
    az38
    6 years ago

    Hi redgun24 

    Try to add measure in your table

    Measure = calculate(count('Table'[Entitlement]);ALLSELECTED('Table'[Entitlement]))

    then in Filters pane add "Measure" to a "Filters on this visual" and check Measure is greater than 1 

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi redgun24 

Try to add measure in your table

Measure = calculate(count('Table'[Entitlement]);ALLSELECTED('Table'[Entitlement]))

then in Filters pane add "Measure" to a "Filters on this visual" and check Measure is greater than 1 

redgun24's avatar
redgun24
New Member
6 years ago

Hey Az38,

 

I was able to get this to work. Thank you!

Az38 = calculate(count('Conflicts & Entitlements'[Entitlement]), ALLSELECTED('Conflicts & Entitlements'[Entitlement]))