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.

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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

Thanks Jihwan_Kim for your help, I had a little adjust in the measure

 

Distinct: 

CALCULATE(
    DISTINCTCOUNT('STO'[Documento_de_compras])
)
 
Distinct 2:
CALCULATE(
    DISTINCTCOUNT('STO'[Documento_de_compras]), REMOVEFILTERS('STO'[Aderencia na Cadeia]), 'STO'[Aderencia na Cadeia]<>BLANK()
)
 
Thanks for all.