Forum Discussion

SwaroopRoyM's avatar
SwaroopRoyM
Icon for Helper II rankHelper II
9 years ago

Data Formatting and Parameterized report

Hi,   I have a filter (both page level/report level) in my report (pbix). my requirement is to display data in visuals based on the selection made. The issue here is i've to get the data from separ...
Michiel's avatar
Michiel
Icon for Resolver III rankResolver III
9 years ago

If you have filter values t1 and t2, you'll have a table in your model that contains these values. When you add a column to this table with a number value (I always use powers of 2 for this, so in this case 1 and 2), it is possible to detect the value selected by evaluating the sum of the number value, e.g. SUM(Selection[Code]).

Taking data from one or the other table is a matter of creating multiple measures, e.g.

Result1 = SUM(Table1[Value])

Result2 = SUM(Table2[Value])

 

The measure to be used in the report can select on of these using SWITCH:

Result = SWITCH(SUM(Selection[Code]), 1, [Result1], 2, [Result2])