Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HI I have the below requirement.
The slicer will dynamically update the Below report.
THanks,
RamsK
Hi @Anonymous ,
It can't be implemented in single table. I created a sample with a new irrelative table you can have a try.
Measure = VAR a = SELECTEDVALUE('Table'[KPI]) VAR b = CALCULATE(SUM(Table1[Values]),FILTER('Table1',Table1[Name] = "BM Top" || Table1[Name] = "Successful"||Table1[Name]="UnSuccess"|| Table1[Name]="BestRate")) VAR c = CALCULATE(SUM(Table1[Values]),FILTER('Table1',Table1[Name] = "TNTR" || Table1[Name] = "RRTR")) return IF(a = "SSLR" || a = "DSLR" || a = "DDPR" ,b,IF( a = "DX" || a = "AX", c,SUM(Table1[Values])))
I have attached my sample below you can download.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI,
I have downloaded the PBIX file and seen, it was good.
But, Actually in my case i need to elobarte more its my wrong, The KPI list have 5 Values
what ever the measure im showin in Table view are not column values , its all are different 5 measures.
Table 1: with Quarter, and 4 Measues and those 4 measures works with first 3KPI values.
Table 2: with Quarter and 2 measures and those 2 measures works with last 2 KPI values.
as the above, i said i dont want to put every thing into 1 table ( Quarter, 6 Measusres ) bec if i put them together i will see nulls for alternative meausre. which i dont want .
based on first 3 KPI values which i select from drop down works on only 4 measures with other graaphs..
based on last 2 KPI values when i select from dropdown works on only 2 measures with other graph.
I'm not able to achive that.
THanks for you response
Hi,
Thankyou so much for the response, but first 3 measures are one fact, and the other two measures are in differnt fact.
can i go ahead with replacing the table names in the logic? and let you know.
Any Suggession please?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |