Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey guys
Hopefully someone can help. I have two columns in a table which reports TRUE or FALSE based on criteria being met.
I wish to have the count of TRUE/FALSE and represent the difference between 8 TRUE and 2 FALSE as 80% / 20% in a visual chart.
How is this possible, I have played with Measures and filters but cant seem to get it working as I need it.
Thanks, Ben
Solved! Go to Solution.
Hi @bh_prism ,
If I understand you correctly, put the below measure into a card visual and you'll get what you want:
TRUE/FALSE =
VAR TRUE_ =
CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column1] = TRUE () )
+ CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column2] = TRUE () )
VAR FALSE_ =
CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column1] = FALSE () )
+ CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column2] = FALSE () )
VAR Total_ =
COUNTROWS ( 'Table' ) * 2
VAR TRUE_Percent =
DIVIDE ( TRUE_, Total_, BLANK () )
VAR FALSE_Percent =
DIVIDE ( FALSE_, Total_, BLANK () )
RETURN
TRUE_Percent & " / " & FALSE_Percent
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @bh_prism ,
If I understand you correctly, put the below measure into a card visual and you'll get what you want:
TRUE/FALSE =
VAR TRUE_ =
CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column1] = TRUE () )
+ CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column2] = TRUE () )
VAR FALSE_ =
CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column1] = FALSE () )
+ CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Column2] = FALSE () )
VAR Total_ =
COUNTROWS ( 'Table' ) * 2
VAR TRUE_Percent =
DIVIDE ( TRUE_, Total_, BLANK () )
VAR FALSE_Percent =
DIVIDE ( FALSE_, Total_, BLANK () )
RETURN
TRUE_Percent & " / " & FALSE_Percent
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@bh_prism , you can have measures like these
divide(calculate(countrows(Table), table[flag]= "True"),calculate(countrows(Table))) // if boolean , table[flag]= True()
divide(calculate(countrows(Table), table[flag]= "False"),calculate(countrows(Table))) // if boolean , table[flag]= False()
Hi, yes it is boolean data type. Thanks
Try these two measures:
True =
VAR True_ = CALCULATE(COUNTROWS('Table') , 'Table'[Column1] = TRUE())
VAR Total = COUNTROWS('Table')
Return
DIVIDE(True_,total,blank())
False =
VAR Total = COUNTROWS('Table')
VAR False_ = CALCULATE(COUNTROWS('Table') , 'Table'[Column1] = FALSE())
Return
DIVIDE(False_,Total,BLANK())
They calculate the % for one column. Use them together in a chart to get the distribution for that column.
/ J
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |