Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Help with % by category

Hello, I need to visualize the percentage of status for each document. I have an measure but it's not showing all the status % % Status = DIVIDE(CALCULATE(DISTINCTCOUNT('Planilha1'[Doc...
General Comment
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    Sorry I don't think I understand 100%. I cannot get the number, that you provided, by pbix file. 

    I assume you are asking about the below?

    Please check the below picture and the attached pbix file.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Jihwan_Kim ,

 

Thanks for your help.

 

But unfortunately it was not what I expected. Trying to explain it better what I need is really the total percentage of the categories over the months.

 

In excel through pivot table I get what I need, a percentage of my 2 categories. I needed to reproduce in Power BI, but the DIVIDE measure with my parameters is not working well.

 

PBI:

 


Excel:

 

 

I save the excel file example on same folder:
https://1drv.ms/u/s!Avq1zGJizBimsUCECKbCmKD7UL7g?e=yZmBqc​ 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,Anonymous 

Can you tell me if your problem is solved? If yes, please accept Jihwan_Kim 'sreply as solution.

If you have already solved it yourself,share your solution and accept it as a solution that will help other community members who have the same problem as you.

 

Best Regards,

Leroy Lu