Forum Discussion

pattajoh's avatar
pattajoh
Regular Visitor
6 years ago
Solved

Need urgent help

Hello,   Good day to everyone out there. I need a help from you.   Below shown is a table where I need to have a column ("Tax impacted Direct") after "% Direct" showing a value (% Direct * Total ...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    pattajoh 

    Try this modified measure please:

    Tax impacted Direct = 
VAR _INDIRECT = 
CALCULATE(
    SUM(Report[Indirect]),
    ALLEXCEPT(Report,'Code List'[Code]))

VAR _DIRECT = 
CALCULATE(
    SUM(Report[Direct]),
    ALLEXCEPT(Report,'Code List'[Code]))    
RETURN

IF( NOT(ISFILTERED('Sup List'[Sup])) && ISBLANK(_DIRECT),
    _INDIRECT,
 COALESCE(   

 _INDIRECT * 'Report'[% Direct], BLANK()))

     

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn

  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    pattajoh 

    plesae try

    Measure 2 = 
VAR _SUM=CALCULATE(sum(Report[Indirect]),ALLEXCEPT(Report,'Code List'[Code]))
RETURN IF([% Direct]=0 && NOT ISFILTERED('Sup List'[Sup]),_SUM,_SUM * 'Report'[% Direct]+0)
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
6 years ago

pattajoh 

Can you share a sample of your source data that you use to build the matrix?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn