Forum Discussion

Krunalbpatel's avatar
Krunalbpatel
Helper III
9 years ago
Solved

Distinct Count based on multiple column

Hi,   I want to display value which is as described below. My calculation is like this   var a =Distinct count of value 1 var b= Count of Value 2 var ans=b/a   I want to display ans as my re...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Krunalbpatel,

    Please change the formula of var b to the following formula:

    var b = COUNTROWS(
 SUMMARIZE(Table,Table[Name],Table[Value1],Table[Value2])
)


    I create a table visual to display your expected result. For more details, you can review the example in this attached PBIX file:https://1drv.ms/u/s!AhsotbnGu1NogXByWhS2F551DemE.



    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Krunalbpatel,

Please change the formula of var b to the following formula:

var b = COUNTROWS(
 SUMMARIZE(Table,Table[Name],Table[Value1],Table[Value2])
)


I create a table visual to display your expected result. For more details, you can review the example in this attached PBIX file:https://1drv.ms/u/s!AhsotbnGu1NogXByWhS2F551DemE.



Thanks,
Lydia Zhang

Krunalbpatel's avatar
Krunalbpatel
Helper III
9 years ago

Hi Lydia Zhang,

 

Thank you for your reply. I got my solution and its works fine for me.

 

Thanks and Regards,

Krunal Patel