Forum Discussion

siac161's avatar
siac161
New Member
2 years ago
Solved

Help with dax

Hi I'm trying to build a clustered chart.  The Y axis are a column that have Regions. The X axis is a distinct count of ID's The legends are the Years The issue that I have is that I want to ...
DAX
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, siac161

    Maybe you can try the following DAX 

    Percentage per Year = 
VAR TotalCountPerYear = CALCULATE(DISTINCTCOUNT(Table[ID]), ALL(Table), VALUES(Table[Year]))
VAR ClusterCount = DISTINCTCOUNT(Table[ID])
RETURN DIVIDE(ClusterCount, TotalCountPerYear)

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

     

    How to Get Your Question Answered Quickly 

    Best Regards

    Yongkang Hua

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

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Did you mean to select "Percentage of Column Total" ?