One Value if All Criteria Are the Same

[Anonymous]

Hi

Is there a way to only show one value of bdr_hfl if bkjrcode, reknr, datum, transtype, transsubtype & project are all the same?

Thanks...tksnota...

[Anonymous]

Hi lbendlin ,thanks for the quick reply, I'll add more.

Hi @Anonymous ，

Regarding your question, how do you plan to aggregate these values into one value?

Best Regards,
Wenbin Zhou

[Anonymous]

@Anonymous: you had a point about the aggregation. are you able to help if I changed the condition wherein only one aggregated value if project = bdr_hfl or (transtype B, N, P, V)

[lbendlin]

yes, create a measure that checks these conditions and returns 1 if they are all met, 0 otherwise, Then use that measure as a visual filter.

[Anonymous]

Hi,

Can I do it via M language if so please share the code?

Thanks...tksnota...

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...