Forum Discussion

Almiwork's avatar
Almiwork
Frequent Visitor
4 years ago

Measure misbehaving when adding more columns to matrix

Hi all, I'm in need of a measure that allows me to distribute sales coming from sub_channelgrouping = Unknown into my other rows. This should be based on the share that each row have of the total sa...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Almiwork , I have done only chance in if. But this part you need to revisit

 

(CALCULATE(SUM('Customer Status & Traffic Sales'[actual_sales]), 'Customer Status & Traffic Sales'[Sub_ChannelGrouping] = "Unknown") * SUM('Customer Status & Traffic Sales'[actual_sales]) / CALCULATE(SUM('Customer Status & Traffic Sales'[actual_sales])

 


Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Almiwork 

    Access Denied. Can you check if your sample file is set to "Public on the web" in the Google Drive link sharing window？

     

    Best Regards,
    Community Support Team _ Eason