Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Solved! Go to Solution.
Define one table with a selection values
example
SelectionTable
Item |
Daily |
Cumulative |
Then switch your column/measure based on the slicer selection.
Try something similar to below.
Measure =
VAR _item =
SELECTEDVALUE ( SelectionTable[Item] )
VAR result =
SWITCH (
TRUE (),
_item = "Daily", SUM ( 'Table'[DailyValue] ),
_item = "Cumulative", SUM ( 'Table'[CumulativeValue] )
)
RETURN
result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Hi @sayali_deshmukh ,
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as solution. You could share your own solutions as well. More people who encounter the same issue will benefit from here. If you are still confused about it, please some sample data and the expected result to us.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
This might help: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titl...
Define one table with a selection values
example
SelectionTable
Item |
Daily |
Cumulative |
Then switch your column/measure based on the slicer selection.
Try something similar to below.
Measure =
VAR _item =
SELECTEDVALUE ( SelectionTable[Item] )
VAR result =
SWITCH (
TRUE (),
_item = "Daily", SUM ( 'Table'[DailyValue] ),
_item = "Cumulative", SUM ( 'Table'[CumulativeValue] )
)
RETURN
result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
User | Count |
---|---|
105 | |
69 | |
48 | |
47 | |
47 |