Forum Discussion
Solved
Measure as Filter
Hi All,
I have 2 measures, used to calculate Open deals and lost deal.
I have created a tabular view to display all the deals and income and other related fields. Mow I want to add the measure lost and open as slicer and this table should respond if I select open or lost and if I dont select anything or both.
I checked few solutions on youtube and I have created a DAX for that, but it's not able to filter out the data in the tabular view.
Lost Funding Deal = CALCULATE([Funding Leads], 'Deal'[Stage]="Lost")
Open Deals (All) = calculate([Open Funding Deal],All('Date'))
# deal by stat =
VAR op = [Open Deals (All)]
return
IF(
HASONEVALUE('Table'[stat]),
SWITCH(TRUE(),
VALUES('Table'[val])=1, op,
VALUES('Table'[val])=2, [Lost Funding Deal])
)
Hi gaurav8494,
Why don't you create a column for Lost and Open Deals using the conditions that you have used in your measures. Then use that column as the field in the slicer which will filter the table visuals.
Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI
2 Replies
Hi gaurav8494,
Why don't you create a column for Lost and Open Deals using the conditions that you have used in your measures. Then use that column as the field in the slicer which will filter the table visuals.
Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BILegend!!
