Forum Discussion

alfordtp's avatar
alfordtp
Frequent Visitor
7 years ago
Solved

Filter by parent row total

This seems like a very simple operation, but I'm farily new to DAX/PowerBI so I need some help.   I'm showing this in an Excel pivot table, but I'm really using this in Power BI desktop.   I have...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi alfordtp,

     

    Do I need to create a distinct count of customers as a variable and then filter on that?  

     

    Yes. You could create a measure as below. 

    Measure =
CALCULATE ( DISTINCTCOUNT ( Table1[Customer] ), ALL ( Table1[Customer] ) )

    Select the Matrix, add this measure to visual level filter and set its value to 1.

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi alfordtp,

 

Do I need to create a distinct count of customers as a variable and then filter on that?  

 

Yes. You could create a measure as below. 

Measure =
CALCULATE ( DISTINCTCOUNT ( Table1[Customer] ), ALL ( Table1[Customer] ) )

Select the Matrix, add this measure to visual level filter and set its value to 1.

Best regards,

Yuliana Gu