topic Re: Percentage of total measure in DAX Commands and Tips

Percentage of total measure

Shaki — Thu, 20 Jan 2022 11:59:44 GMT

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!

Re: Percentage of total measure

amitchandak — Thu, 20 Jan 2022 14:13:21 GMT

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.

Re: Percentage of total measure

Shaki — Thu, 20 Jan 2022 19:58:07 GMT

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).

Re: Percentage of total measure

Anonymous — Tue, 25 Jan 2022 03:08:54 GMT

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.