Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello
I have a measure with this code:
CY-0 InnNS NEW =
var selection=SELECTEDVALUE('Year Filter Table'[Year Filter])
var option1=calculate([_CY_0_InnNS],FILTER('ION_ByProject_2020_2021', OR (Year('ION_ByProject_2020_2021'[Period])=2021 && selection=2021, Year('ION_ByProject_2020_2021'[Period])=2020 && selection=2020)))
var option2=calculate([_CY_1_InnNS],FILTER('ION_ByProject_2020_2021', (Year('ION_ByProject_2020_2021'[Period])=2020 && selection=2020)))
return
option1+option2
If i put this in a table, it only works if column Period is included.
If i remove the period column, the table displays nothing.
Is there a way to fix this? Basically i do not want the period column in the table, just Project Name and the Measure.
Thank you
Solved! Go to Solution.
Try adding the all function to see if it works:
FILTER(ALL('ION_ByProject_2020_2021'),XXXXXXXXXXXXXXXXXX
Hi @tim10 ,
Unfortunately,not clear about your model. Any chance you can share a PBIX file with dummy data?
Please remove any sensitive data before uploading.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, Thank you for your reply. I will not be able to provide sample data unfortunately.
Try adding the all function to see if it works:
FILTER(ALL('ION_ByProject_2020_2021'),XXXXXXXXXXXXXXXXXX
this appears to solve my issue. thank you for your support
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |