Forum Discussion

alecjbeckett's avatar
alecjbeckett
Frequent Visitor
9 years ago
Solved

True or False Percent Gauge

Hi All,   I am trying to convert the below table to a gauge.   What i would like to have the gauge show Cases solved that are TRUE as a percentage of the total number of CASE IDs.   Bit of a po...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Create 3 Measures.  First measure would be a simple "CountRows" measure.  That will give you the total number of cases.  This measure will change depending on your filter context.  Next create a 2nd measure which is going to count the number of True rows, this can be done doing something like:

    CountTrue = CALCULATE(
    COUNTROWS('YourTable'),
    'YourTable'[Case Solved?] = TRUE()
)

    Lastly the 3rd measure is what is your percentage, which will be the [CountTrue] / [CountAll]

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Create 3 Measures.  First measure would be a simple "CountRows" measure.  That will give you the total number of cases.  This measure will change depending on your filter context.  Next create a 2nd measure which is going to count the number of True rows, this can be done doing something like:

CountTrue = CALCULATE(
    COUNTROWS('YourTable'),
    'YourTable'[Case Solved?] = TRUE()
)

Lastly the 3rd measure is what is your percentage, which will be the [CountTrue] / [CountAll]

 

Dilesha08's avatar
Dilesha08
Frequent Visitor
6 years ago

How can we visualizre this?