Forum Discussion
Powerbi Find most common value
Hey i have a issue with powerbi that i cant figure out. The data looks like this Suplier: | Item no: | T00001 | STD0001 T00002 | STD0564 T00003 | STD06646 M00005 | STD05454...
In that case create a new calculated column and paste that DAX formula into it.
This formula;
Common Supplier =FIRSTNONBLANK(TOPN(1,VALUES(Table'[Item no.]),RANKX(ALL('Table'[Item no.]),[Supplier Count],,ASC)),1)
Hi Anonymous .
1)Create a measure using COUNTROWS as;
Supplier Count=COUNTROWS(Table).
2)Create a measure for Common Supplier using RANKX as;
Common Supplier =
FIRSTNONBLANK(
TOPN(
1,
VALUES(Table'[Item no.]),
RANKX(ALL('Table'[Item no.]),[Supplier Count],,ASC)
),
1
)
3)Drag a Card visual and add Coomon Supplier measure onto it.
4)Drag a slicer and add Supplier field into it.
4)Drag a slicer and add Supplier field into it.
5)You will get the desired output.
I tried it myself and I am attaching screenshot of the same.
If this post answers your question, then please mark it as 'Accept as Solution' and give it a big thumbs up.
Regards,
Sanket Bhagwat.