DAX Measure to determine % of parent row in column chart

0
votes

I've been struggling to find a way to achieve the result of a matrix visualization in Power BI, in a line and clustered column chart.

I have tried using ALLSELECTED, ALL, ALLEXCEPT in order to ignore one filter but no matter how I try it, I'm not reaching my end goal. 

CarCountPerCategory = 
CALCULATE(
    DISTINCTCOUNT(Table[CarID]),
    ALLSELECTED(Table[Filter])
    )

This still breaks down the measure to the Filter level instead of ignoring it. I am looking for something that will give me the total distinct count regardless of the Filter column. E.g. TimesReshopped 1 - 190 on all 3 columns, TimesReshopped 2 - 182 on all 3 columns of the Filter Column series. I need this as a sidestep in order to divide the distinct car count to the total distinct car count per times reshopped in order to reach the percentage that I am looking for. (the one in the matrix)

enter image description here

Can someone help me with some advice? Thank you.

2
powerbidax
Can you post a sample of what your data table looks like? - Alexis Olson

2 Answers

1
votes

Try this:

[Total Category Count]:=
SUMX ( SUMMARIZE ( Table, Table[TimesReshopped] ), [Count of CarID] )
0
votes

I got to the bottom of this by using ALLEXCEPT and providing all the filter that I was using:

CarCountPerCategory = 
CALCULATE(
    DISTINCTCOUNT(Table[CarID]),
    ALLEXCEPT(Table,Table[Year],Table[Month],Table[LocationName],Table[CustCode],Table[TimeReshoped])
    )