Forum Discussion
CountIf Measure
I may just be searching incorrectly, but I am looking to create a measure that would function like the "count if" function in Excel. I am tracking number of incidents across time (columns) per da...
Hi,
In the Query Editor, right click on the first column and select "Unpivot Other Columns". In the matrix visual, drag Date to the row labels and Value to the Column labels. Write this measure
Count = countrows(Data)
Hope this helps.