Forum Discussion
Help with DAX IF statement error
Hi DemoFour,
With your measure, you could not just use the column ['PBO test 1 - Client Details'[Age]], you could try to convert the 'PBO test 1 - Client Details'[Age] to CALCULATE(SUM('PBO test 1 - Client Details'[Age])) in your formula.
Regards,
Daniel He
Hi DemoFour,
With your measure, you could not just use the column ['PBO test 1 - Client Details'[Age]], you could try to convert the 'PBO test 1 - Client Details'[Age] to CALCULATE(SUM('PBO test 1 - Client Details'[Age])) in your formula.
Regards,
Daniel He
Hi v-danhe-msft
Thank's for your reply.
I got the following to work
But whilst the suggestion you made worked, I could not traslate it into visual. I think I need to do some more work on understanding CALCULATE and SUM to understand them better within BI.
kind regards
Hi DemoFour ,
It is pleasant that your first issue could be solved, could you please mark my reply as answered if possible?
And with your second issue, I suggest to you to re-create a topic in the community and you could also refer to below link about CALCULATE:
https://www.absentdata.com/power-bi/how-to-use-calculate-in-power-bi/
https://databear.com/power-bi-tips-calculate-one-of-the-most-used-dax-functions/
Regards,
Daniel He
