Help needed with the Measure

[AleksandrMe]

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

[AleksandrMe · Accepted solution]

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 

[lbendlin]

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