Forum Discussion

salimlko's avatar
salimlko
New Member
3 years ago

PERCENTAGE Related ISSUE

I have a unpivoted table in power BI like below having ads in column Q9 and ratings in Response column where 1 is least interested and 10 is very interested. There are total 30 rows in my raw data s...
Need Help
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

salimlko Please refer Below Code
Count of Index =
CALCULATE ( [Count Of Response], ALLSELECTED ( Table[Q9] ) )

*********************************************************************
Percentof Grand Total =
DIVIDE ( [Count Of Response], [Count of Index], 0 )

salimlko > Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!

 

salimlko's avatar
salimlko
New Member
3 years ago

Hi Mahesh,

 

Thanks for looking into my query but actually it's not working.

 

I created below two measures as per your suggestion but it;s not working.

 

Count of Index =
CALCULATE ( count(Q9_Interest[Response]), ALLSELECTED ( Q9_Interest[Q9] ) )
Percentof Grand Total =
DIVIDE ( count(Q9_Interest[Response]), count(Q9_Interest[Index]), 0 )

 

Below is the screenshot for your reference.

 

 

Thanks,

Salim

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

    salimlko please Format this measure As Percentage [Percentof Grand Total ] .

     

    salimlko Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!