Hi everyone, I am facing a problem when sum up a measure on different levels.
I have Location table:
I have a already have a measure which calculates the cumulative sales, the result is similiar to:
now I want to count the number of products where the total value is greater than 4 based on product, which means
and I want the matrix can show on different levels, which means I can see on Province level:
and also on City level
Because my cumulative sales is measure, the number is wrong when I go up to higher level.
Can anyone help me with it? Thank you very much!
Hi @sagdec12 ,
Could you pls share your pbix file ? And remember to remove confidential data.
@sagdec12 , I think isinscope can help
if(isinscope (Table[City]), [Meausre1], [Measure2])
Proud to be a Super User!
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!