Forum Discussion
Responsive ResidentHow to write this Condition in Power BI
It is working and I am accepting it as a solution however if you could tell me any other simpler way then it would be great as it seems a lot confusing.
If you wish to take into account that you might have ties in your data (as in the sample file) you could use the following two measures in your file.
I have tested them and they produce correct result.
Most frequent country =
CONCATENATEX(
CALCULATETABLE(
VALUES(Data[COUNTRY]);
TOPN(1;VALUES(Data[COUNTRY]);CALCULATE(COUNTROWS('Data'));DESC)
);
'Data'[COUNTRY];", "
)
Most freq product with status true =
CONCATENATEX(
CALCULATETABLE(
VALUES(Data[PRODUCTID]);
TOPN(1;VALUES(Data[PRODUCTID]);CALCULATE(COUNTROWS('Data'));DESC);
'Data'[STATUS] = TRUE()
);
'Data'[PRODUCTID];", "
)
Br,
Magnus
Responsive ResidentIt is working and I am accepting it as a solution however if you could tell me any other simpler way then it would be great as it seems a lot confusing.