Forum Discussion

DimitrisBech's avatar
DimitrisBech
Frequent Visitor
7 years ago

KPI Variance Visualization with any filtered combination

Hi to all fellow Datanauts,   It will be very much appreciated if you can help on how to tackle a variance calculation between KPI's. Table and data are formated as per below logic.   Now the ac...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI DimitrisBech,

 

I'd like to suggest you add a variable table to measure with summarize function to summarize filter records from 'allselected' table and add ADR measure calculation to summary table.

 

Then you can simply calculate on this temporary summary table to help calculate out which you wanted.

 

Regards,

Xiaoxin Sheng

DimitrisBech's avatar
DimitrisBech
Frequent Visitor
7 years ago

Hi Anonymous,

 

and thank you for your answer.

I do not understand your approach.

Is the below what you are referring to?

Variance Table

Alternatively, can you/someone please offer some help, in my fileset?

 

Best,

DB

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI DimitrisBech,

     

    I mean you can create a variable to store filtered summary table and add new column to store measure result, then use sumx or other function to get result from variable table.


    In addition, I found you already create a transform data table, Maybe you can try to use allselected function to get filtered records, then you summary records with specific conditions.

     

    Measure =
CALCULATE (
    SUM ( Table[Arrangement Revenues] ),
    FILTER ( ALLSELECTED ( Table ), Table[Period] = "Actual" )
)
    - CALCULATE (
        SUM ( Table[Arrangement Revenues] ),
        FILTER ( ALLSELECTED ( Table ), Table[Period] = "Budget" )
    )

     

    Regards,

    Xiaoxin Sheng