Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help needed with the Measure

Good day 

 

I have a model with number of similar file combined in the data query. All files are being anilued and filtered by column SOURCE NAME. 

 

What I'm looking now is the MEASURE helping me to COUNT value "High" in the risk factor column. 

 

Primary - The aim is to see number of "high" for each Source Colum

Secondary - Percent oh High agains the rest of rows per Source Column 

 

Help is much appreciated!

Cheers

Aleks

DAX help needed
  • Anonymous's avatar
    Anonymous
    5 years ago

    Good day, 

     

    I tried, but I have problems woth these formulas in general unlike in EXCEl it tells you exactly how to create forrmulas. For now I have sorted this issue by using visuals, adding required data columnt adiditonally to LEGEND of visual and used permanent filters to remove all other values I do not need. 

     

    So for now I think question is solved, but have lots of other - probably best to start another thread 🙂

     

    Thanks

    Aleks 

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Have you worked with the CALCULATE() statement yet, and used filters?  Where are you stuck?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Good day, 

     

    I tried, but I have problems woth these formulas in general unlike in EXCEl it tells you exactly how to create forrmulas. For now I have sorted this issue by using visuals, adding required data columnt adiditonally to LEGEND of visual and used permanent filters to remove all other values I do not need. 

     

    So for now I think question is solved, but have lots of other - probably best to start another thread 🙂

     

    Thanks

    Aleks