Slicer making percent 100% rather than the actual percent

[michael_knight]

Hi, 

I'm having trouble with a slicer that I've added to my report. I originally wanted to create a slicer with the options from an IF statement, like so..

After some advice on here I could only do this by creating a new column using this code...

Spread Outcome = IF([Spread Offer Low] = [Final Option Price]&&[Spread Offer High]=[Final Option Price], "Fixed",

IF([Average] >= [Final Option Price], "Low",

IF([Average] < [Final Option Price], "High")))

When I try to use this slicer I keep on getting this problem.

I want to eventually have Fixed, Low and High in a Line Chart and use the slicer to only show whichever one I select in the slicer, but I can't get past this problem 

Any help would be welcomed.

Thanks,

Mike

[AnkitBI]

Can you share sample data or PBIX file?

[michael_knight]

Yep, here you go @AnkitBI 

https://www.dropbox.com/s/slabqc5gelj2bd0/FA%20-%20Test.pbix?dl=0

[AnkitBI · Accepted solution]

Your Total formula seems wrong. It shall be like 

Total =
CALCULATE (
    COUNT ( 'Properties - Spread'[Agent] ),
    ALL ( 'Properties - Spread'[Spread Outcome] )
)

Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.