Forum Discussion
How to Fix Subtotal
Hello - Looking for some, please. I tried to solve it through various solutions on the PowerBI community/Youtube as most of the time is HASONEVALUE function but I am not able to solve so sharing my p...
Hi,
Does this measure work?
Measure = SUMX(VALUES(Data[Display Country name]),[Current Weighted avg])
Hi Ashish, Thank you for the comment. I solved it with some of the research on the web. I used the ISINCOPE function and added the syntax similar to what you suggested.
IF(ISINSCOPE(Region[Display Country Name]),SUMX(vTable,[Weighted WD]) ,SUMX(vTable,Divide([Country Sales], [Total Sales])* [Working days]))
Thank you for your time.
Best regards