Forum Discussion

C_H's avatar
C_H
Advocate I
7 years ago
Solved

Subselect result only with measures

Hi,   I have follwing sample data in a table: Client  Year    Revenue 4711    2017    100 4711    2018    200 4712    2017    101 4712    2018    201 4713    2018    202 4714    2018    203 ...
Tips and Tricks
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Hello C_H,

     

    you can build the below model and add this measure:

     

    Measure = 
CALCULATE(
    SUM( Revenue[Revenue] ),
    CALCULATETABLE(
        VALUES( Clients[Client] ),
        Years[Year] = 2017,
        CROSSFILTER( Revenue[Client], Clients[Client], Both )
    )
)

     

     

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

Hi C_H!

 

I highly advise to adopt the Dimensional Modelling approach when using Power BI. 

I understand that at the beginning it can be a bit tricky for people coming from an OLTP background but that is how Tabular models work best. Besides, for data savvy people such as your power users it should not be rocket science to grasp it :)

C_H's avatar
C_H
Advocate I
7 years ago

LivioLanzo

BTW: it works also with only one table. Thanks a lot :smileyvery-happy:

 

Measure =
CALCULATE (
    SUM ( test_table[Revenue] ),
    CALCULATETABLE ( VALUES ( test_table[Client] ), test_table[Year] = 2017 )
)