Forum Discussion
Solved
Percentage from Text Columns
I have 2 questions. I need to create 2 measures from text columns and display as cards ignoring the slicer. I have a table UPS, it has a Location colum and Maintenance Bypass column (Text) & Du...
Hi cghanta Try these please
Measure1 = VAR TotalLocations = COUNTROWS(ALL(UPS)) VAR NoMaintenanceBypass = COUNTROWS( FILTER(ALL(UPS), UPS[Maintenance Bypass] = "No") ) RETURN DIVIDE(NoMaintenanceBypass, TotalLocations, 0) * 100Measure2 = VAR TotalLocations = COUNTROWS(ALL(UPS)) VAR WithDualUPS = COUNTROWS( FILTER(ALL(UPS), UPS[Dual UPS] = "Yes") ) RETURN DIVIDE(WithDualUPS, TotalLocations, 0) * 100
the following mesaure works,
%No Manit Bypass = DIVIDE( CALCULATE( COUNTROWS( UPS ), UPS[Maintenance Bypass] = "Yes" ), COUNTROWS( UPS ) )
how do I add filter to ignore the slicer? The above is calculating per row, due to the slicer (giving answer 1 for teh 1st 3 cities), I want it to calculate % for all rows ignoring the slicer (the answer should be 1/4 = .25) and display 25%
how do I add filter to ignore the slicer? The above is calculating per row, due to the slicer (giving answer 1 for teh 1st 3 cities), I want it to calculate % for all rows ignoring the slicer (the answer should be 1/4 = .25) and display 25%