Forum Discussion
All Except Issue- Find a % value using ALLEXCEPT
Hi, I created a measure for sum the total for respective of tag, So i got a total values of indiviual tag id.there i used all except measure to create the total for the respective tag ID. after ...
Hi， NavaneethaRaju ；
You could create a measure.
Total Procedures =
CALCULATE(SUM('Tag Usage Fact'[No of Procedures]),ALLEXCEPT('Tag Usage Fact','Tag Usage Fact'[Tag ID]))% of Usage = SUM('Tag Usage Fact'[No of Procedures])/[Total Procedures]The final show:
Best Regards,
Hi v-yalanwu-msft ,
I also used this measure before, this measure only showing all total,
but actually the total should be respective of the selected date range. without that Filters(Order date) i can't display the total for selected date range.