Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculated measures not working correctly with calculated table

Hi everybody,    I have to create a price tiering in Power BI something like the picture below and the range can be variable anytime by the user.    For variability every product need a con...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-lid-msft 

 

Thank you for your answer but this solution is not working in my scenario. 

 

I can't use calculated measure, because in the end of the tier calculation I have to count how many economy, standard, premium and super premium product each manufacturer have. 

 

It's necessary because i would like to show the distribution in a graph. 

Something like this:

 

Thanks, 

Anett 

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Sorry for our late reply, We can create a separation table as the Legend:s

 

TiersTable = {"Economy","Standard","Premium","Super Premium"}

 

Then we can use another measure as the value to count the number to used in the barchart:

 

Measure = 
COUNTROWS (
    FILTER (
        SUMMARIZE (
            'SALES VALUE',
            'SALES VALUE'[SEGMENT],
            'SALES VALUE'[PRODUCT],
            "TYS", [Tiers TY]
        ),
        [TYS] IN FILTERS ( 'TiersTable'[Value] )
    )
)

 


Best regards,