Percentage of total measure

[Shaki]

Hi,

I want to create a percentage of total measure filtered by two columns.

I want to calculate the % of total trips filtered by weekday and by fiscalweek day...

The results of the measure suppose to look like in the picture below

Thanks in advence!

[Anonymous]

Hi @Shaki ,

So do you want to correct the wrong Row - Total(100%) ?

If so, you could use HASONEVALUE() like:

Measure = IF(HASONEVALUE('Table'[Week]),1,0)

If you are still confused about it, please provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Shaki]

Hi @amitchandak , thanks for your replay

This is the matrix table... the % of total time is excactly what I wanted with the same numbers of the top right visual. But the % of total shortdayname doesn't get the same result as the left top visual. Is it even doable?

(Total trip and hours are from the same table, the shortdayname is from another table).

[amitchandak]

@Shaki , In such case it usually

divide([measure], calculate([measure], allselected()) )

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.