Help count of true and False in the dax

[Anonymous]

Hi Team below is my data

any body help dax .

Count of TRUE and FALSE  based on TITLE (out should be second table)

Title	Approved1	Approved2	Approved3	Approved4	Approved5	Approved6
Hardware upgrade	FALSE	TRUE	FALSE	TRUE	TRUE	FALSE
CPU	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE
Mouse	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE
Gartner Access	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE
Air con maintainance	FALSE	FALSE	TRUE	TRUE	TRUE	TRUE
Testing environment	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE

my out but should be below

Count of true and False based on the title

Title	TRUE	FALSE
Hardware upgrade	3	3
CPU	1	5
Mouse	3	3
Gartner Access	3	3
Air con maintainance	4	2
Testing environment	0	6

[amitchandak · Accepted solution]

@Anonymous , Unpivot into all Approved column in Approved column

https://radacad.com/pivot-and-unpivot-with-power-bi

The try measure like

TRUE = calculate(countrows(Table),Table[Approved ] ="TRUE")

FALSE= calculate(countrows(Table),Table[Approved ] ="FALSE")

[MFelix]

Hi @Anonymous ,

First of all you should unpivot your data in the query editor the you just need to make a matrix with the following setup:

• Rows: Title
• Columns: Value (column with TRUE OR FALSE value)
• Values: Count of attribute (Column with APPROVED1, 2, 3).

Check PBIX attach.