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)
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

jpattamthanam 

Do you want to change the sup and code places like below? Then you either have the direct value or indirect value. How to use the previous logic to calculate?

 

jpattamthanam's avatar
jpattamthanam
Frequent Visitor
5 years ago

Ryan,

 

I get %Direct with changed matrix as shown below. The problem is value ("%Direct" X ("Total of Indirect")) is not showing up with the DAX formulae you helped me with.

 

Regards

 

John

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    5 years ago

    jpattamthanam 

    I am sry that I didn't see the matrix you showed. please share again.