Forum Discussion
Switch or If Function
The D_Index_Forum and the Seasonal Demand Index.
And the classification (your original request) do you do it on the sum of the values on the Seasonal Demand Index?
Instead of letting PowerBI to sum the values, please create a simple measure like this:
Total Demand Index = CALCULATE (SUM([Seasonal Demand Index]))You can do it either via a calculated column or a table to Legend.
Since this is a different topic I suggest you close this thread and do some digging first.
These may help:
- https://community.fabric.microsoft.com/t5/Desktop/How-can-I-plot-my-DAX-measure-as-a-legend-as-well-as-values/m-p/2423682#M867725- https://www.reddit.com/r/PowerBI/comments/13gpo7m/is_there_a_way_to_use_a_measure_as_legend_on_a/
- https://community.fabric.microsoft.com/t5/Desktop/Use-measure-as-chart-legend/m-p/1237315#M547738
Hope it helps.
Thank you, there is no text. I did check the data.
Do a simple test, create two measures:
DC_1=
IF('ItemsOutbound'[Seasonal Demand Index] > 1, "High Demand","N/A")
DC_2=
IF('ItemsOutbound'[Seasonal Demand Index] > 0, "High Demand","N/A")
See which one returns garbage vs the data you have in your column. If both return N/A then there is something wrong with the data.
DC1 all N/A and DC2 all high demand.
So
'ItemsOutbound'[Seasonal Demand Index]is between 0 and 1. Is this a calculated column? Could you please create another test column in the same table with the below formula and screenshot the values?
D_Index_Forum = VALUE([Seasonal Demand Index])Values below:
This is for seasonal deman index:
Seasonal Demand Index = Divide('SCM ItemsOutbound'[ABS - Custom],('SCM ItemsOutbound'[Average Demand]),0)Thank you