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
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


Best regards,

 

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,

     

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

    Hi Anonymous ,

     

    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,