Forum Discussion

IF's avatar
IF
Post Prodigy
1 year ago
Solved

Values from different columns

Hi, I am using three filter on the filter panel in the report. FilterG: LevelG Filter1: Level1 Filter2: Level2   As you can see at the file, there are three different cards. However, I want t...
Need Help
  • Shivu-2000's avatar
    Shivu-2000
    1 year ago

    Hi IF 

     

    Try using this dax measure

     

    Dynamic ID Count =
    VAR Filter1Selected = NOT ISBLANK(SELECTEDVALUE(Main[Level1]))
    VAR Filter2Selected = NOT ISBLANK(SELECTEDVALUE(Main[Level2]))
    VAR FilterGSelected = NOT ISBLANK(SELECTEDVALUE(Main[LevelG]))

    RETURN
    SWITCH(
    TRUE(),
    Filter1Selected && Filter2Selected, CALCULATE(DISTINCTCOUNT(Main[ID]), Main[Level2] = 3),
    Filter1Selected, CALCULATE(DISTINCTCOUNT(Main[ID]), Main[Level1] = 3),
    Filter2Selected, CALCULATE(DISTINCTCOUNT(Main[ID]), Main[Level2] = 3),
    FilterGSelected, CALCULATE(DISTINCTCOUNT(Main[ID]), Main[LevelG] = 3),
    CALCULATE(DISTINCTCOUNT(Main[ID]), Main[LevelG] = 3) -- Default case if no filters are selected
    )

     

    And pull this on the card visual.

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Happy to help!

Shivu-2000's avatar
Shivu-2000
Responsive Resident
1 year ago

Hi IF 

 

Try using this dax measure

 

Dynamic ID Count =
VAR Filter1Selected = NOT ISBLANK(SELECTEDVALUE(Main[Level1]))
VAR Filter2Selected = NOT ISBLANK(SELECTEDVALUE(Main[Level2]))
VAR FilterGSelected = NOT ISBLANK(SELECTEDVALUE(Main[LevelG]))

RETURN
SWITCH(
TRUE(),
Filter1Selected && Filter2Selected, CALCULATE(DISTINCTCOUNT(Main[ID]), Main[Level2] = 3),
Filter1Selected, CALCULATE(DISTINCTCOUNT(Main[ID]), Main[Level1] = 3),
Filter2Selected, CALCULATE(DISTINCTCOUNT(Main[ID]), Main[Level2] = 3),
FilterGSelected, CALCULATE(DISTINCTCOUNT(Main[ID]), Main[LevelG] = 3),
CALCULATE(DISTINCTCOUNT(Main[ID]), Main[LevelG] = 3) -- Default case if no filters are selected
)

 

And pull this on the card visual.

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!