Forum Discussion

kdixon5490's avatar
kdixon5490
Helper III
2 years ago
Solved

Dax calculation not working with Filter or Row data.

I'm rather new to Power BI so please be patient with this question.   I have a data table that has the followoing columns. Date            <Date>, Dynamic       <Int>, Sold            <float>, ...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    2 years ago

    kdixon5490 , if you need % of total of sold
    a new measure =
    Divide(Sum(Table[Sold]), calculate(sum(Table[Sold]), allselected()) )

     

    or % of total attendance

     

    Divide(Sum(Table[attendance]), calculate(sum(Table[attendance]), allselected()) )

     

    Power BI Percent of Total and Percent of SubTotal: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s

     

     

amitchandak's avatar
amitchandak
Super User
2 years ago

kdixon5490 , if you need % of total of sold
a new measure =
Divide(Sum(Table[Sold]), calculate(sum(Table[Sold]), allselected()) )

 

or % of total attendance

 

Divide(Sum(Table[attendance]), calculate(sum(Table[attendance]), allselected()) )

 

Power BI Percent of Total and Percent of SubTotal: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s