1 year ago
#325748
Thennarasu
how to get Distinct count based on the condition in power bi
I have table name called Data. in this table have a two column Product ,QTY
Now I have created new measure for DISTINCT Value for QTY column
Distict Count Qty = CALCULATE(DISTINCTCOUNT(Data[Qty]))
Now Table looks like after added above measure
from above table I want to get count for three conditions form Distinct Count Qty measure.
if values have < 4 and if values have => 4 , if value have =12 .
this three count I want from distinct value measure .
powerbi
dax
powerquery
powerbi-desktop
power-bi-report-server
0 Answers
Your Answer