Semi-aggregated measures

Hi Anonymous,

You can use the HASONEVALUE function to control this see the following forumula example

measure =
switch(true(),
hasonevalue('table'[user]) && not(hasonevalue('table'[date]), blank(),
hasonevalue('table'[user]) && hasonevalue('table'[date]), [measure],
, blank())

Hope this Helps,
Richard
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Greetings @mochabits , here you should condition the value shown in the subtotals, the HASONEVALUE or ISINCOPE function you can use a lot for this, here I leave you a link to see how they work, HASONEVALUE: https://youtu.be/Q_l-6oYOdJ8, ISINSCOPE: https://youtu.be/OQUqdT7UDeQ