Forum Discussion

ramiouanes's avatar
ramiouanes
Advocate I
8 years ago

Sort Matrix and Chart with KPI Values

Hello,   I have a SSAS tabular model with a Time Analysis dimension and a KPI dimension. The KPI Dimension contains members with values of type: Sales, Budget...etc. The Time Analysis Dimension c...
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi ramiouanes,

 

" IF( KPI[Name]="Sales" && TimeAnalysis[Name]="Periodic"; calculate(sum(Fact[valueColumn]); Filter( Fact[KPIColumn]="Sales"));Blank()); "

 

<--- Does this mean you want to create two slicer charts based on KPI[Name] column and TimeAnalysis[Name] column? And if user select "Sales" and "Periodic", return value of calculate(sum(Fact[valueColumn]); Filter( Fact[KPIColumn]="Sales"))? If so, you should modify your measure like pattern below:

Measure =
IF (
    SELECTEDVALUE ( KPI[Name] ) = "Sales"
        && SELECTEDVALUE ( TimeAnalysis[Name] ) = "Periodic",
    CALCULATE (
        SUM ( Fact[valueColumn] ),
        FILTER ( Fact, Fact[KPIColumn] = "Sales" )
    ),
    BLANK ()
)

In addtion, to sort values in a column, just right click on the column then click "Sort".

 

Regards,

Jimmy Tao

  • ramiouanes's avatar
    ramiouanes
    Advocate I
    8 years ago

    Hello v-yuta-msft,

     

    Actually, I'm not trying to put a slicer for the measure.

     

    It's a matrix that I'm using with KPI and Time analysis as columns and a column Value (That contains the sum of all my KPIs) as values.

     

    The sort does not work though. The idea is to be able to sort only one KPI. And the KPI here are grouped in one column which is KPI[Name]. So the right click/Sort doesn't work.