Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello world,
I have this is issue
as you can see a single invoice number can have multiple statuses. I want to create a measure and filter by it so that if invoice number has 2 statuses, then the final status of the whole invoice number would be validated, in not the leave the status as is.
I was considering a group calculation with min/max but I couldn't make it working.
Any ideas?
Thanks in advance
Solved! Go to Solution.
Hi, @Anonymous
Please check the below picture and the measure.
Status Measure =
VAR currentinvoice =
MAX ( 'Table'[AP Invoice Number] )
RETURN
IF (
COUNTROWS (
FILTER ( ALL ( 'Table' ), 'Table'[AP Invoice Number] = currentinvoice )
) > 1
&& "Validated"
IN SUMMARIZE (
FILTER ( ALL ( 'Table' ), 'Table'[AP Invoice Number] = currentinvoice ),
'Table'[AP Invoice Status]
),
"Validated",
SELECTEDVALUE ( 'Table'[AP Invoice Status] )
)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
Please check the below picture and the measure.
Status Measure =
VAR currentinvoice =
MAX ( 'Table'[AP Invoice Number] )
RETURN
IF (
COUNTROWS (
FILTER ( ALL ( 'Table' ), 'Table'[AP Invoice Number] = currentinvoice )
) > 1
&& "Validated"
IN SUMMARIZE (
FILTER ( ALL ( 'Table' ), 'Table'[AP Invoice Number] = currentinvoice ),
'Table'[AP Invoice Status]
),
"Validated",
SELECTEDVALUE ( 'Table'[AP Invoice Status] )
)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Anonymous
Add the following measure:
Final Ivoice Status =
var __current = MAX(Table4[AP Invoie No]) return
IF(
CALCULATE(
COUNTROWS(Table4),
Table4[AP Invoie No] = __current,
REMOVEFILTERS(Table4)
) = 2,
"Validated",
UNICHAR(8302)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Wish I could also click as solution on this one too cause it works great too!Thanks!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
61 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |