Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello there, I have a measure that only provides one of two sums in a specific Deal, here it is below:
Solved! Go to Solution.
Hello @v-yiruan-msft I did actually manage to find a solution just recently, thanks to Amit in another thread.
Here is the measure below that is used:
@Anonymous , Try like
DealPO =
VAR _POTotal = [VO PO Total]
VAR _POBilled = [PO Billed]
RETURN
if( isfiltered('Deals (CRM)'[Deal Name]) ,
SUMX (
VALUES ( 'Deals (CRM)'[Deal Name] ),
IF ( ISBLANK ( _POTotal ), _POBilled, _POTotal )
) , blank())
Hi @amitchandak
I'm not sure why but that's showing up a blank value on my card for [PO Billed] when a Deal isn't selected.
Why do you think that is?
Hi @Anonymous ,
Do you want to implement the DealPO value to be displayed only when the Deal Name slicer has the options selected. If the slicer doesn't have any value selected, it won't be displayed. Do I understand correctly? If not, could you please explain the result you want with specific sample and relevant screenshots. Thank you.
In addition, could you share with us the formulas for the two measures [VO PO Total] and [PO Billed] and the sample data of the table involved in the visual in order to provide you with a suitable solution? Thank you.
Best Regards
Hello @v-yiruan-msft I did actually manage to find a solution just recently, thanks to Amit in another thread.
Here is the measure below that is used: