Measure as Filter

[gaurav8494]

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])

    )

[gaurav8494]

Legend!!

[Shaurya · Accepted solution]

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