I have a da whic calculate total usage % for a tag, on the front end I am ignoring anything which is 100%
SO in this if we see that for tag id 0034609 % of usage is 15% . But if i select that tag id in the slicer it shows blank. It is taking usage for that tag as 100 % and since I have hidden 100% to not to be shown so blank appears, if i remove 100% removal from filter it would show the tag id but with % of usage as 100%.
The % of usage dax is
% of Usage = SUM('Procedure Fact'[Procedures])/[Total Procedures(Other Territory)]
I also tried all except in the dax but it din seem to work, can someone please help.