Forum Discussion
Solved
How to exclude a specific table dimension value using CALCULATE fomula
Hi, I have a problem getting the DAX with the following example: I have a source data of Product Group and Sales I created a Product Group Filter. I created a custom measure using the...
Hi roytap,
You can create two measures below:
Total Product Group = CALCULATE(SUM(Sheet1[Sales]), FILTER(ALL(Sheet1),Sheet1[Product Group]<>"E"))
Product weightage = DIVIDE(CALCULATE(SUM(Sheet1[Sales])),[Total Product Group])For more information, you can see attached pbix file.
Best Regards,
Qiuyun Yu
Hi roytap,
You can create two measures below:
Total Product Group = CALCULATE(SUM(Sheet1[Sales]), FILTER(ALL(Sheet1),Sheet1[Product Group]<>"E"))
Product weightage = DIVIDE(CALCULATE(SUM(Sheet1[Sales])),[Total Product Group])
For more information, you can see attached pbix file.
Best Regards,
Qiuyun Yu