Hi all, I'm fairly new to Power BI and still trying to grasp the logic behind all the DAX and how to utilize them. Any help is greatly appreciated!
Here is my sample data table:
What I'm trying to achieve: (below is the result I got from Excel by running pivot table counting total PO per year per each item and countif on the side table)
- count/% of total item with transaction (PO) > 2 in each year and illustrate on canvas as the sum table (right) below.
Thank you in advance for your help!
Go to Solution.
According to your description, it seems that you want to get below result, right(if count(po)>1, then show 1 in Year)?
If so, you could use below measure to see whether it work or not
Measure 5 =
COUNT ( test[PO] ),
test[Item #] = MAX ( test[Item #] )
&& test[Year] = MAX ( test[Year] )
) > 1,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
This measure works
Measure = COUNTROWS(FILTER(SUMMARIZE(VALUES(Data[Item #]),Data[Item #],"ABCD",COUNTROWS(Data)),[ABCD]>1))+0
Hope this helps.
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!