Forum Discussion

pborah's avatar
pborah
Icon for Solution Sage rankSolution Sage
5 years ago

Measure column not filtering in matrix visual

I'm using Power BI Report Server Jan 2020 build. Following is my measure for one of the columns in a matrix table -       MonthEndOpen = VAR EOM = MAX('Calendar'[EOM]) RETURN SUMX( FILTER(ALL...
Need Help
Show and Tell
Tips and Tricks
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, pborah 

Not very clear.

It seem that you are using sumx(all（table）,1) .
Are you trying to count the number of days that meet certain conditions?

 

Maybe you can take a  try to  use ALLEXCEPT('Table','Table'[UNIT]) to replace all(table).

 

Best Regards,
Community Support Team _ Eason

 

 

  • pborah's avatar
    pborah
    Icon for Solution Sage rankSolution Sage
    5 years ago

    v-easonf-msft any chance I can send you a pbix privately. This was worked on by a pair of third party consultants (who themselves consulted google while building this) before I was hired. The whole thing seems to be a jumbled mess.