Please bear with me, this is the first time of my life I've used an online forum, and I am new to Power BI for only a few weeks!
I have a column that my external query provides amounts using weighting values. This column is at the lowest level of
data grain in my fact table, because it uses weighting values at that grain to create the amounts.
Call this lowest level in my Fact data as 'AttributeTest'.
Call the higher level in my Dimension as 'Project'.
Now, I've created a measure for the level 'Project' that sums those weighted amounts of 'AttributeTest' up to Project, and then
calc's a percentage for Project from those sums. This measure is filter-aware, and I've proven that it calc's correctly when a I filter on 'Projects' in my Viz.
My problem:
Now I need to create a DAX case (SWITCH) that will compare this measure Project-level percentage from my measure to thresholds in a Project-level Dimension table
(they are also percentages) so that I can determine if the Project-level percentage falls;
>= PASS threshold (a 'PASS' condition)
< PASS threshold AND (&&) > FAIL threshold (a 'WARN' condition)
< FAIL threshold (a 'FAIL' condition)
Else will be 'NONE' condition.
I've been at this for two days and just cannot nail it
