Defining a measure for several columns

Question

Hi,i have a table like this&nbsp;sale IDseller IDError type 1type 2type 3type 4type 5140736742552error&nbsp;error&nbsp;&nbsp;154564108554&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;205626417558&nbsp;&nbsp;errorerror&nbsp;42810745554&nbsp;error&nbsp;&nbsp;&nbsp;32667322'552&nbsp;&nbsp;error&nbsp;error&nbsp;I want a measure to sum number of errors for all table, like total number of errors = 7&nbsp;The only wayi thinking to do is =CALCULATE( COUNT('data'[type2), data'[type2) = "error")then sum all this measures.Please, I need a quicker way

greg_deckler · Answer

EngCicero&nbsp;I would highly recommend unpivoting your "error" columns. If not that, then you are stuck with MC Aggregations:&nbsp;Multi-Column Aggregations (MC Aggregations) - Microsoft Power BI Community

ashish_mathur · Answer

Hi,
In the Query Editor, select the first 2 columns, right click and select "Unpivot Other Columns".&nbsp; Now write this measure
Errors = calculate(countrows(data),data[value]="error")
Hope this helps.

engcicero · Answer

Hello&nbsp;Ashish_Mathur&nbsp;n&nbsp;Greg_Deckler&nbsp;.I didn't make myself clear enough, tihs error cells are tests for a process, this functions are not in my database. those errors are the results of more complex Switchs tests.I'm stucked hereThank you both anyway

ashish_mathur · Answer

Hi,
I am sorry but i do not understand your requirement.

greg_deckler · Answer

EngCicero&nbsp;OK, then you want MC Aggregations:&nbsp;Multi-Column Aggregations (MC Aggregations) - Microsoft Power BI Community

Forum Discussion

Defining a measure for several columns

7 Replies

Related content

un define

Slicer for filtering several columns

Fabric User Define Functions

Uncaught ReferenceError: ClipboardItem is not defined

ClipboardItem is not defined

sale ID	seller ID	Error type 1	type 2	type 3	type 4	type 5
140736742	552	error		error
154564108	554
205626417	558			error	error
42810745	554		error
32667322'	552			error		error