Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Need Slicer Based on Percentage using Measure

Hi    I had created a table with Difference and Percentage using Measures   I wanted to have slicer with the classifications based on the values from the dax but the outcome proved different as s...
Need Help
rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi Anonymous -you should use a calculated column instead of a measure for your classifications

replace with following calculated column 

Classification05 =
IF(Append_WIP[Percentage04] = 0 || Append_WIP[Percentage04] < 0.4, BLANK(),
IF(Append_WIP[Percentage04] >= 0.4 && Append_WIP[Percentage04] < 0.55, "Attention Needed",
IF(Append_WIP[Percentage04] >= 0.55 && Append_WIP[Percentage04] < 0.65, "Monitor The Account",
IF(Append_WIP[Percentage04] >= 0.65 && Append_WIP[Percentage04] <= 1, "Action Needed",
IF(Append_WIP[Percentage04] > 1, "Value > 100%"
)))))

 

the above logic resolves by making them suitable for use in slicers. 

 

I hope this works. 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,

 

I used the 2 Codes and both had the same results.

 

Screenshot 1 should only showed  Action Needed but it also contained Attention Needed plus blank.

 

 

Screenshot 2: How can I put a comment for Infinity "No PO With Cost" and NaAn "No PO, No Cost"

 

Screenshot 3 should only showed "Attention Needed" but also produced blanks

 

 

Thanks...tksnota...